<?php

namespace Home\Model;

use Think\Model;

class gInfoModel extends Model {

    protected $trueTableName = 'tb_g_info';

    public function getList($where, $page = 1) {
        $result = $this->alias('a')
                ->join("left join `tb_g_door` as b on a.id=b.gid")
                ->where($where)
                ->field("b.id,b.code,b.nickname,b.codex,b.codey,b.status,b.functional,b.orderId")
                ->limit(($page - 1) * 24, 24)
                ->select();
        return $result;
    }

}
